<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Filtering data based on dates</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
p.whs2 { margin-left:0px; font-size:9pt; }
p.whs3 { margin-left:40px; }
p.whs4 { font-size:9pt; }
img_whs5 { border:none; width:17px; height:17px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs2 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nRetrieving specific data from sources: Filters\nCreating a stand-alone filter\nFiltering data based on dates");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Filtering data based on dates</h1>
<p>This filter is an attribute form qualification that enables you to filter 
 data based on an attribute with a date data type. For example, you can 
 create a date qualification on the Day attribute to return data for only 
 those days between January 1, 2008 and February 12, 2008.</p>
<p>Use the following procedure to create a date qualification filter. </p>
<p>For an introduction to attribute form qualifications, see 
<a HREF="att_form_qualification.htm">Filtering 
 data based on attribute forms: Attribute form qualification</a>.</p>
<h2>To qualify on a date</h2>
<ol type="1" class="whs1">
	
<li class=p><p>On the project's main page, click <span style="font-weight: bold;"><B>Create 
 Filter</B></span>. The New Filter page opens.</p></li>
	
<li class=p><p>In the pane on the left, navigate to the attribute with 
 the date data type on which you want to qualify.</p></li>
	
<li class=p><p>Right-click the attribute and select <span style="font-weight: bold;"><B>Add 
 to Filter</B></span>.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, select the attribute and click <span style="font-weight: bold;"><B>Add 
 &gt;</B></span> to add the attribute to the Filter panel.</p></li>
	</ul>
	
<li style=" font-size: 9pt; " class=p><p class="whs2">Click 
 <span style="font-weight: bold;"><B>Qualify</B></span>.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs2">From 
 the first drop-down menu, select the form you want to filter data based 
 on. This is usually <span style="font-weight: bold;"><B>ID</B></span>.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs2">From 
 the next drop-down menu, select the operator that describes how you want 
 to filter data. If you want to use a data range in your filter, select 
 <span style="font-weight: bold;"><B>Between</B></span>.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs2">In 
 the last field, type the value(s) or click the calendar to select a date 
 to use to qualify on the attribute form. This is the value that will be 
 compared against the data in your data source. </p></li>
</ol>
<p class="whs3">If you are using a date range in your filter, 
 click the calendar again to select the second date. For example, if you 
 want to filter data so the report shows results between January 1 2008 
 and February 12 2008, click the calendar and select January 1 2008, then 
 click the calendar again and select February 12 2008. </p>
<ol start="8" type="1" class="whs1">
	
<li style=" font-size: 9pt; " class=p><p class="whs4">Click 
 the <span style="font-weight: bold;"><B>Apply</B></span> icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs5"> to create your filtering condition.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs4">Click 
 <span style="font-weight: bold;"><B>Save As</B></span>. The Save As dialog box 
 opens.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs4">Navigate 
 to the folder where you want to save the filter. Enter a <span style="font-weight: bold;"><B>Name</B></span> 
 and <span style="font-weight: bold;"><B>Description</B></span> for the filter, 
 and click <span style="font-weight: bold;"><B>OK</B></span>. Your new filter 
 is saved.</p></li>
</ol>
<p class="whs4">The filter you created can now be added to a 
 report. For steps, see 
<a href="Creating_a_filter.htm" style="font-size: 9pt;">Adding 
 a stand-alone filter to a report</a>.</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
